CREATE TABLE [lgw].[Customer_PhoneNumbers]
(
[PhoneNumberId] [bigint] NOT NULL IDENTITY(100, 1),
[CustomerId] [bigint] NOT NULL,
[BusinessPhone] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ResidencePhone] [nvarchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Mobile1] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[Mobile2] [nvarchar] (12) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[isPrimary] [bit] NOT NULL,
[CreatedUser] [nvarchar] (25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[CreatedDate] [datetime] NOT NULL,
[UpdatedUser] [nvarchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[UpdatedDate] [datetime] NOT NULL
) ON [PRIMARY]
ALTER TABLE [lgw].[Customer_PhoneNumbers] ADD 
CONSTRAINT [PK__Customer__D2D34F9112C8C788] PRIMARY KEY CLUSTERED  ([PhoneNumberId]) ON [PRIMARY]
GO
